sg2 | Materials for Structural geology 2 course | Learning library

I'm a macro newbie and I'm just making a simple macro program using a nested for loop and an excel table. I have attached my code here.

What I want is when I input P,Q, and SGF values, I want to see results for each loop indices in row wise in "Table4". (My table has four columns and they should be displyed a,b,Y and (SGF-Y) values.) But this code only creates a one new row and shows results of the last loop value. (When a=10 and b=10) But I actually need 100 results. Hope you understand my question. Thank you!

[![enter image description here][1]][1]

• I have 2 different security groups in stage and prod
• For lambda function I have to give SG1 if its stage and SG2 if its prod
• Do i need to write separate resources in template or I can given any conditional expressions
• My security group SG1 and SG2 is deployed from this template only

This question has been asked before but without reproducible example. Unfortunately I have been running into the same problem with my data set. I would like some help. I am a R beginner but I have tried to make a reproducible example. Sorry if the code is clunky!

I have a setup like this.

1. Application Load Balancer(internet facing) LB1 with entry in Route 53 as loadbalancer1.com

2. LB1 is in security group sg1 which has inbound rule to accept all Https requests.

3. LB1 has target group attached which has an EC2 instance instance1 which belongs to security group sg2

4. sg2 has inbound rule which specifies traffic can only come from sg1

5. I have another EC2 instance instance2 in Security Group sg3. This instance wants to access instance1. It does this by calling the load balancer loadbalancer1.com(on port 443 i.e Https)

This setup works. Now I want to make an improvement. Since loadbalancer1.com will only be accessed from instance2. I want to change inbound rules of security group sg1 to accept traffic only from security group sg3. If I do this, loadbalancer1.com is no more reachable from instance2.

Any idea why?

I'm trying to export list variables and use them via TF_VAR_name and getting error while combining them with toset function.

Success scenario:

terraform apply -auto-approve

I got a dictionary of dataframes ,dataframes, which are time based profiles with values x and y for each point in time. The following shows the dictionary and one dataframe of this dictionary

dataframes={'SG1':Dataframe, 'SG2':Dataframe, 'SG3':Dataframe, 'SG4':Dataframe, 'SG5':Dataframe}

With those I want to create a dictionary of new dataframes; dataframes2, where the values x and y are a sum of the old dataframes multiplied with a value. This value is contained in another nested dictionary:

base_dict={'area1':{'SG1':0.0,'SG2':1.0}, 'area2':{'SG1':1.0,'SG2':0.0}}

( note: I shorted the dictionary)

At the end dataframes2 should look like this:

dataframes2={'area1':Dataframe, 'area2':Dataframe} While area1 looks like this:

I think of using mutliple for loops, but I am not really sure where to start here. Can you help me?

Having issues attempting to add three securiy groups to the ec2 instance below. How do I add the two shared-services-sg* from the data "aws_security_groups" list as well as newly created SG? The data aws_security_groups will return two security groups shared-services-sg1 and shared-services-sg2. Im also creating a new security group john_app_sec_group2.

I am using Excel VBA to create and organize color palettes and gradients using Cell interior color and multiple colorspaces. I am successful in getting the formula and code to get the numeric RGB values of selected cells, but when I try to put those values in a custom Userform, it does not populate for some reason.

Userform in question. The R, G and B textboxes should be populated by 191, 143, 0

Here is the sub before it runs the userform. It is set up so it will either run a different userform or messagebox depending on how I do my cell selection for gradients.

I have terraform script that creates N security groups: